CREATE TABLE [dbo].[PrescriptionVoid]
(
[PrescriptionID] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VoidReason] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VoidPerson] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VoidDate] [datetime] NOT NULL CONSTRAINT [DF_PrescriptionVoid_VoidDate] DEFAULT (getdate()),
[Remark] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PrescriptionVoid] ADD CONSTRAINT [PK_PrescriptionVoid] PRIMARY KEY CLUSTERED  ([PrescriptionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PrescriptionVoid] ADD CONSTRAINT [FK_PrescriptionVoid_Prescription] FOREIGN KEY ([PrescriptionID]) REFERENCES [dbo].[Prescription] ([PrescriptionID])
GO
